﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CADISDataSet2" targetNamespace="http://tempuri.org/CADISDataSet2.xsd" xmlns:mstns="http://tempuri.org/CADISDataSet2.xsd" xmlns="http://tempuri.org/CADISDataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="CADISSpare" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CADISSpare (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.JLD004_Interface_M3_Cadis.My.MySettings.GlobalReference.Default.CADISSpare" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="F1004TableAdapter" GeneratorDataComponentClassName="F1004TableAdapter" Name="F1004" UserDataComponentName="F1004TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CADISSpare (MySettings)" DbObjectName="CADIS.dbo.F1004" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[F1004] WHERE (([JLID] = @Original_JLID) AND ((@IsNull_JLITNO = 1 AND [JLITNO] IS NULL) OR ([JLITNO] = @Original_JLITNO)) AND ((@IsNull_JLQTY = 1 AND [JLQTY] IS NULL) OR ([JLQTY] = @Original_JLQTY)) AND ((@IsNull_JLUOM = 1 AND [JLUOM] IS NULL) OR ([JLUOM] = @Original_JLUOM)) AND ((@IsNull_JLSERI = 1 AND [JLSERI] IS NULL) OR ([JLSERI] = @Original_JLSERI)) AND ((@IsNull_JLAUF = 1 AND [JLAUF] IS NULL) OR ([JLAUF] = @Original_JLAUF)) AND ((@IsNull_JLTYP = 1 AND [JLTYP] IS NULL) OR ([JLTYP] = @Original_JLTYP)) AND ((@IsNull_JLNUM = 1 AND [JLNUM] IS NULL) OR ([JLNUM] = @Original_JLNUM)) AND ((@IsNull_JLDSERI = 1 AND [JLDSERI] IS NULL) OR ([JLDSERI] = @Original_JLDSERI)) AND ((@IsNull_JLDSC1 = 1 AND [JLDSC1] IS NULL) OR ([JLDSC1] = @Original_JLDSC1)) AND ((@IsNull_JLWKTE = 1 AND [JLWKTE] IS NULL) OR ([JLWKTE] = @Original_JLWKTE)) AND ((@IsNull_JLDOYR = 1 AND [JLDOYR] IS NULL) OR ([JLDOYR] = @Original_JLDOYR)) AND ((@IsNull_JLMOYR = 1 AND [JLMOYR] IS NULL) OR ([JLMOYR] = @Original_JLMOYR)) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLCOST = 1 AND [JLCOST] IS NULL) OR ([JLCOST] = @Original_JLCOST)) AND ((@IsNull_JLPRICE = 1 AND [JLPRICE] IS NULL) OR ([JLPRICE] = @Original_JLPRICE)) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)) AND ((@IsNull_LastEditDate = 1 AND [LastEditDate] IS NULL) OR ([LastEditDate] = @Original_LastEditDate)) AND ((@IsNull_CreationDate = 1 AND [CreationDate] IS NULL) OR ([CreationDate] = @Original_CreationDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_JLID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="JLID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLITNO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLQTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLUOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLSERI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLSERI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLSERI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLAUF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLNUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSERI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLWKTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLWKTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLWKTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLWKTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastEditDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastEditDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastEditDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastEditDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreationDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreationDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[F1004] ([JLITNO], [JLQTY], [JLUOM], [JLSERI], [JLAUF], [JLTYP], [JLNUM], [JLDSERI], [JLDSC1], [JLWKTE], [JLDOYR], [JLMOYR], [JLYEAR], [JLCOST], [JLPRICE], [JLTDAY], [LastEditDate], [CreationDate]) VALUES (@JLITNO, @JLQTY, @JLUOM, @JLSERI, @JLAUF, @JLTYP, @JLNUM, @JLDSERI, @JLDSC1, @JLWKTE, @JLDOYR, @JLMOYR, @JLYEAR, @JLCOST, @JLPRICE, @JLTDAY, @LastEditDate, @CreationDate);
SELECT JLID, JLITNO, JLQTY, JLUOM, JLSERI, JLAUF, JLTYP, JLNUM, JLDSERI, JLDSC1, JLWKTE, JLDOYR, JLMOYR, JLYEAR, JLCOST, JLPRICE, JLTDAY, LastEditDate, CreationDate FROM F1004 WHERE (JLID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLSERI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLWKTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLWKTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastEditDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastEditDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT JLID, JLITNO, JLQTY, JLUOM, JLSERI, JLAUF, JLTYP, JLNUM, JLDSERI, JLDSC1, JLWKTE, JLDOYR, JLMOYR, JLYEAR, JLCOST, JLPRICE, JLTDAY, LastEditDate, CreationDate FROM dbo.F1004</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[F1004] SET [JLITNO] = @JLITNO, [JLQTY] = @JLQTY, [JLUOM] = @JLUOM, [JLSERI] = @JLSERI, [JLAUF] = @JLAUF, [JLTYP] = @JLTYP, [JLNUM] = @JLNUM, [JLDSERI] = @JLDSERI, [JLDSC1] = @JLDSC1, [JLWKTE] = @JLWKTE, [JLDOYR] = @JLDOYR, [JLMOYR] = @JLMOYR, [JLYEAR] = @JLYEAR, [JLCOST] = @JLCOST, [JLPRICE] = @JLPRICE, [JLTDAY] = @JLTDAY, [LastEditDate] = @LastEditDate, [CreationDate] = @CreationDate WHERE (([JLID] = @Original_JLID) AND ((@IsNull_JLITNO = 1 AND [JLITNO] IS NULL) OR ([JLITNO] = @Original_JLITNO)) AND ((@IsNull_JLQTY = 1 AND [JLQTY] IS NULL) OR ([JLQTY] = @Original_JLQTY)) AND ((@IsNull_JLUOM = 1 AND [JLUOM] IS NULL) OR ([JLUOM] = @Original_JLUOM)) AND ((@IsNull_JLSERI = 1 AND [JLSERI] IS NULL) OR ([JLSERI] = @Original_JLSERI)) AND ((@IsNull_JLAUF = 1 AND [JLAUF] IS NULL) OR ([JLAUF] = @Original_JLAUF)) AND ((@IsNull_JLTYP = 1 AND [JLTYP] IS NULL) OR ([JLTYP] = @Original_JLTYP)) AND ((@IsNull_JLNUM = 1 AND [JLNUM] IS NULL) OR ([JLNUM] = @Original_JLNUM)) AND ((@IsNull_JLDSERI = 1 AND [JLDSERI] IS NULL) OR ([JLDSERI] = @Original_JLDSERI)) AND ((@IsNull_JLDSC1 = 1 AND [JLDSC1] IS NULL) OR ([JLDSC1] = @Original_JLDSC1)) AND ((@IsNull_JLWKTE = 1 AND [JLWKTE] IS NULL) OR ([JLWKTE] = @Original_JLWKTE)) AND ((@IsNull_JLDOYR = 1 AND [JLDOYR] IS NULL) OR ([JLDOYR] = @Original_JLDOYR)) AND ((@IsNull_JLMOYR = 1 AND [JLMOYR] IS NULL) OR ([JLMOYR] = @Original_JLMOYR)) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLCOST = 1 AND [JLCOST] IS NULL) OR ([JLCOST] = @Original_JLCOST)) AND ((@IsNull_JLPRICE = 1 AND [JLPRICE] IS NULL) OR ([JLPRICE] = @Original_JLPRICE)) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)) AND ((@IsNull_LastEditDate = 1 AND [LastEditDate] IS NULL) OR ([LastEditDate] = @Original_LastEditDate)) AND ((@IsNull_CreationDate = 1 AND [CreationDate] IS NULL) OR ([CreationDate] = @Original_CreationDate)));
SELECT JLID, JLITNO, JLQTY, JLUOM, JLSERI, JLAUF, JLTYP, JLNUM, JLDSERI, JLDSC1, JLWKTE, JLDOYR, JLMOYR, JLYEAR, JLCOST, JLPRICE, JLTDAY, LastEditDate, CreationDate FROM F1004 WHERE (JLID = @JLID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLSERI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLWKTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLWKTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastEditDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastEditDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_JLID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="JLID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLITNO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLQTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLUOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLSERI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLSERI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLSERI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLAUF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLNUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSERI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLWKTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLWKTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLWKTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLWKTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastEditDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastEditDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastEditDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastEditDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreationDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreationDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="JLID" ColumnName="JLID" DataSourceName="CADIS.dbo.F1004" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@JLID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="JLID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="JLID" DataSetColumn="JLID" />
              <Mapping SourceColumn="JLITNO" DataSetColumn="JLITNO" />
              <Mapping SourceColumn="JLQTY" DataSetColumn="JLQTY" />
              <Mapping SourceColumn="JLUOM" DataSetColumn="JLUOM" />
              <Mapping SourceColumn="JLSERI" DataSetColumn="JLSERI" />
              <Mapping SourceColumn="JLAUF" DataSetColumn="JLAUF" />
              <Mapping SourceColumn="JLTYP" DataSetColumn="JLTYP" />
              <Mapping SourceColumn="JLNUM" DataSetColumn="JLNUM" />
              <Mapping SourceColumn="JLDSERI" DataSetColumn="JLDSERI" />
              <Mapping SourceColumn="JLDSC1" DataSetColumn="JLDSC1" />
              <Mapping SourceColumn="JLWKTE" DataSetColumn="JLWKTE" />
              <Mapping SourceColumn="JLDOYR" DataSetColumn="JLDOYR" />
              <Mapping SourceColumn="JLMOYR" DataSetColumn="JLMOYR" />
              <Mapping SourceColumn="JLYEAR" DataSetColumn="JLYEAR" />
              <Mapping SourceColumn="JLCOST" DataSetColumn="JLCOST" />
              <Mapping SourceColumn="JLPRICE" DataSetColumn="JLPRICE" />
              <Mapping SourceColumn="JLTDAY" DataSetColumn="JLTDAY" />
              <Mapping SourceColumn="LastEditDate" DataSetColumn="LastEditDate" />
              <Mapping SourceColumn="CreationDate" DataSetColumn="CreationDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CADISDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="CADISDataSet2" msprop:Generator_UserDSName="CADISDataSet2">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="F1004" msprop:Generator_TableClassName="F1004DataTable" msprop:Generator_TableVarName="tableF1004" msprop:Generator_TablePropName="F1004" msprop:Generator_RowDeletingName="F1004RowDeleting" msprop:Generator_UserTableName="F1004" msprop:Generator_RowChangingName="F1004RowChanging" msprop:Generator_RowEvHandlerName="F1004RowChangeEventHandler" msprop:Generator_RowDeletedName="F1004RowDeleted" msprop:Generator_RowEvArgName="F1004RowChangeEvent" msprop:Generator_RowChangedName="F1004RowChanged" msprop:Generator_RowClassName="F1004Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="JLID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnJLID" msprop:Generator_ColumnPropNameInRow="JLID" msprop:Generator_ColumnPropNameInTable="JLIDColumn" msprop:Generator_UserColumnName="JLID" type="xs:long" />
              <xs:element name="JLITNO" msprop:Generator_ColumnVarNameInTable="columnJLITNO" msprop:Generator_ColumnPropNameInRow="JLITNO" msprop:Generator_ColumnPropNameInTable="JLITNOColumn" msprop:Generator_UserColumnName="JLITNO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLQTY" msprop:Generator_ColumnVarNameInTable="columnJLQTY" msprop:Generator_ColumnPropNameInRow="JLQTY" msprop:Generator_ColumnPropNameInTable="JLQTYColumn" msprop:Generator_UserColumnName="JLQTY" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLUOM" msprop:Generator_ColumnVarNameInTable="columnJLUOM" msprop:Generator_ColumnPropNameInRow="JLUOM" msprop:Generator_ColumnPropNameInTable="JLUOMColumn" msprop:Generator_UserColumnName="JLUOM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLSERI" msprop:Generator_ColumnVarNameInTable="columnJLSERI" msprop:Generator_ColumnPropNameInRow="JLSERI" msprop:Generator_ColumnPropNameInTable="JLSERIColumn" msprop:Generator_UserColumnName="JLSERI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLAUF" msprop:Generator_ColumnVarNameInTable="columnJLAUF" msprop:Generator_ColumnPropNameInRow="JLAUF" msprop:Generator_ColumnPropNameInTable="JLAUFColumn" msprop:Generator_UserColumnName="JLAUF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLTYP" msprop:Generator_ColumnVarNameInTable="columnJLTYP" msprop:Generator_ColumnPropNameInRow="JLTYP" msprop:Generator_ColumnPropNameInTable="JLTYPColumn" msprop:Generator_UserColumnName="JLTYP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLNUM" msprop:Generator_ColumnVarNameInTable="columnJLNUM" msprop:Generator_ColumnPropNameInRow="JLNUM" msprop:Generator_ColumnPropNameInTable="JLNUMColumn" msprop:Generator_UserColumnName="JLNUM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDSERI" msprop:Generator_ColumnVarNameInTable="columnJLDSERI" msprop:Generator_ColumnPropNameInRow="JLDSERI" msprop:Generator_ColumnPropNameInTable="JLDSERIColumn" msprop:Generator_UserColumnName="JLDSERI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDSC1" msprop:Generator_ColumnVarNameInTable="columnJLDSC1" msprop:Generator_ColumnPropNameInRow="JLDSC1" msprop:Generator_ColumnPropNameInTable="JLDSC1Column" msprop:Generator_UserColumnName="JLDSC1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLWKTE" msprop:Generator_ColumnVarNameInTable="columnJLWKTE" msprop:Generator_ColumnPropNameInRow="JLWKTE" msprop:Generator_ColumnPropNameInTable="JLWKTEColumn" msprop:Generator_UserColumnName="JLWKTE" type="xs:int" minOccurs="0" />
              <xs:element name="JLDOYR" msprop:Generator_ColumnVarNameInTable="columnJLDOYR" msprop:Generator_ColumnPropNameInRow="JLDOYR" msprop:Generator_ColumnPropNameInTable="JLDOYRColumn" msprop:Generator_UserColumnName="JLDOYR" type="xs:int" minOccurs="0" />
              <xs:element name="JLMOYR" msprop:Generator_ColumnVarNameInTable="columnJLMOYR" msprop:Generator_ColumnPropNameInRow="JLMOYR" msprop:Generator_ColumnPropNameInTable="JLMOYRColumn" msprop:Generator_UserColumnName="JLMOYR" type="xs:int" minOccurs="0" />
              <xs:element name="JLYEAR" msprop:Generator_ColumnVarNameInTable="columnJLYEAR" msprop:Generator_ColumnPropNameInRow="JLYEAR" msprop:Generator_ColumnPropNameInTable="JLYEARColumn" msprop:Generator_UserColumnName="JLYEAR" type="xs:int" minOccurs="0" />
              <xs:element name="JLCOST" msprop:Generator_ColumnVarNameInTable="columnJLCOST" msprop:Generator_ColumnPropNameInRow="JLCOST" msprop:Generator_ColumnPropNameInTable="JLCOSTColumn" msprop:Generator_UserColumnName="JLCOST" type="xs:int" minOccurs="0" />
              <xs:element name="JLPRICE" msprop:Generator_ColumnVarNameInTable="columnJLPRICE" msprop:Generator_ColumnPropNameInRow="JLPRICE" msprop:Generator_ColumnPropNameInTable="JLPRICEColumn" msprop:Generator_UserColumnName="JLPRICE" type="xs:int" minOccurs="0" />
              <xs:element name="JLTDAY" msprop:Generator_ColumnVarNameInTable="columnJLTDAY" msprop:Generator_ColumnPropNameInRow="JLTDAY" msprop:Generator_ColumnPropNameInTable="JLTDAYColumn" msprop:Generator_UserColumnName="JLTDAY" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LastEditDate" msprop:Generator_ColumnVarNameInTable="columnLastEditDate" msprop:Generator_ColumnPropNameInRow="LastEditDate" msprop:Generator_ColumnPropNameInTable="LastEditDateColumn" msprop:Generator_UserColumnName="LastEditDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreationDate" msprop:Generator_ColumnVarNameInTable="columnCreationDate" msprop:Generator_ColumnPropNameInRow="CreationDate" msprop:Generator_ColumnPropNameInTable="CreationDateColumn" msprop:Generator_UserColumnName="CreationDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:F1004" />
      <xs:field xpath="mstns:JLID" />
    </xs:unique>
  </xs:element>
</xs:schema>